--INSERT INTO training_course
SELECT
NULL AS [Id],TrainclassCategory AS [Category],trainclassName AS [Name],NULL AS [Objective],NULL AS [Overview],NULL AS [Outline],NULL AS [ClassHours],NULL AS [Audience],NULL AS [ClosingDate],trainclassbegindate AS [StartDate],NULL AS [TimeSlot],NULL AS [Address],NULL AS [Prerequisites],trainclassfee AS [Price],NULL AS [Contact],NULL AS [Tel],NULL AS [Email],NULL AS [Audiences],NULL AS [Attachments],NULL AS [Lecturers],NULL AS [Notes],NULL AS [Posted],NULL AS [CompanyId],NULL AS [DateCreated],NULL AS [LastUpdated],NULL AS [ModifiedBy],FROM srv_lnk.nchr2008.dbo.TrainClass
SELECT TOP 10 * FROM srv_lnk.nchr2008.dbo.TrainClass
